<html>
<head>
	<title>SQL Relay</title>
	<link rel="stylesheet" href="css/styles.css">
</head>
<body>
<h4>SQL Relay</h4>

<blockquote>
  <p>SQL Relay is a powerful database connection management solution.</p>

<img style="float: left; margin-right: 20px; " src="images/sqlrelay.png"/>
<br/><br/><br/>
With SQL Relay, you can speed up and enhance the scalability of database-driven web-based applications, access databases from unsupported platforms, throttle database access, distribute load over clustered or replicated databases, route queries and migrate applications from one database to another.
<br/><br/>
</blockquote>
<hr/>

<h4>Advantages</h4>

<blockquote>
<a href="features/connectionpooling.html">Persistent Database Connection Pooling</a> - makes database-driven web-based applications faster and more efficient<br/>
<a href="features/proxying.html">Proxying</a> - provides access to databases from unsupported platforms<br/>
<a href="features/throttling.html">Throttling</a> - prevents databases from becoming overloaded<br/>
<a href="features/ha.html">High Availability</a> - provides load balancing and failover with replicated or clustered databases<br/>
<a href="features/queryrouting.html">Query Routing</a> - conditionally sends queries to one database or another<br/>
<a href="features/queryfiltering.html">Query Filtering</a> - prevents queries that match certain patterns from being run at all<br/>
<a href="features/schedules.html">Connection Schedules</a> - constrain database access to specified times<br/>
</blockquote>
<blockquote>
<a href="features/databases.html">Database Support</a> - a wide variety of commercial and open-source databases are supported<br/>
<a href="features/dbabstractionlayers.html">Abstraction Layer Support</a> - drivers for most popular database abstraction layers are provided<br/>
<a href="features/dropinreplacementlibs.html">Drop-In Replacement Libraries</a> - allow many native MySQL or PostgreSQL applications to use SQL Relay without modification<br/>
<a href="features/languages.html">Native API</a> - the powerful native SQL Relay client API supports a wide variety of programming languages<br/>
</blockquote>
<blockquote>
<a href="features/substitutionandbindvars.html">Substitution and Bind Variables</a> - make frequently run queries faster and more efficient<br/>
<a href="features/multirowfetches.html">Multi-Row Fetches</a> - reduce the number of network round-trips<br/>
<a href="features/resultsetcaching.html">Client-Side Result Set Caching</a> - makes paging faster and easier<br/>
<a href="features/suspendedtx.html">Suspended Transactions</a> - allow a single transaction to span multiple web pages<br/>
</blockquote>
<a name="enterprise"/><blockquote>
  <p><b>SQL Relay Enterprise Modules</b> provide advanced features not available in the standard distribution.</p>

<a href="../sqlrenterprise/features/nativeprotocol.html">MySQL Front-End Modules</a> - allow MySQL applications to use SQL Relay without modification and without a drop-in replacement library<br/>
(more Enterprise Modules coming soon...)
</blockquote>
<br/><hr/>

<br/><table>
  <tr>
    <td>    <h4>Administering SQL Relay</h4>

    <p>Guides and references for SQL Relay administration.</p>

    <table>
      <tr>
        <td>        <blockquote>
<a href="admin/installing.html">Building and Installing SQL Relay From Source</a><br/>
<a href="admin/configguide.html">SQL Relay Configuration Guide</a><br/>
<a href="admin/configreference.html">SQL Relay Configuration Reference</a><br/>
<a href="admin/running.html">SQL Relay Command Line Programs</a><br/>
<a href="admin/tuning.html">Tuning SQL Relay</a><br/>
<a target="_blank" href="http://software.firstworks.com/p/current-sql-relay-benchmarks.html">Current Benchmarks</a><br/>
        </blockquote>
</td>
      </tr>
    </table>

</td>
    <td><div style="margin-left: 56px;"/>
</td>
    <td>    <h4>Database How-To's</h4>

    <p>Getting-started guides for various databases supported by SQL Relay.</p>

    <table>
      <tr>
        <td>        <blockquote>
<a target="_blank" href="http://systems.firstworks.com/p/getting-started-with-oracle.html">Oracle</a><br/>
<a target="_blank" href="http://systems.firstworks.com/p/getting.html">SAP/Sybase</a><br/>
<a target="_blank" href="http://systems.firstworks.com/p/getting-started-with-ibm-db2.html">IBM DB2</a><br/>
<a target="_blank" href="http://systems.firstworks.com/p/getting-started-with-mysql.html">MySQL</a><br/>
<a target="_blank" href="http://systems.firstworks.com/p/blog-page_51.html">PostgreSQL</a><br/>
        </blockquote>
</td>
        <td>        <blockquote>
<a target="_blank" href="http://systems.firstworks.com/p/getting-started-with-firebird.html">Firebird</a><br/>
<a target="_blank" href="http://systems.firstworks.com/p/getting-started-with-sqlite.html">SQLite</a><br/>
<a target="_blank" href="http://systems.firstworks.com/p/blog-page_8.html">MS Access (on non-MS platforms)</a><br/>
<a target="_blank" href="http://systems.firstworks.com/p/blog-page_65.html">ODBC (non-MS platforms)</a><br/>
        </blockquote>
</td>
      </tr>
    </table>

</td>
  </tr>
</table>

<h4>Administering Enterprise Modules</h4>

<blockquote>
<a href="../sqlrenterprise/modules/install_modules.html">Installing the SQL Relay Enterprise Modules</a><br/>
<a href="../sqlrenterprise/modules/license_mysql_frontend.html">Licensing the MySQL Front-End Modules</a><br/>
<a href="../sqlrenterprise/modules/configure_mysql_frontend.html">Configuring the MySQL Front-End Modules</a><br/>
</blockquote>
<br/><hr/>

<br/><table>
  <tr>
    <td>    <h4>Connectors</h4>

    <p>SQL Relay provides drivers for most popular database abstraction layers.</p>

    <table>
      <tr>
        <td>        <blockquote>
<b>Guides</b>:<br/>
<a href="programming/ado.net.html">ADO.NET</a><br/>
<a href="programming/perldbi.html">Perl DBI</a><br/>
<a href="programming/pythondb.html">Python DB-API</a><br/>
<a href="programming/phppdo.html">PHP PDO</a><br/>
<a href="programming/odbc.html">ODBC</a><br/>
<a href="programming/jdbc.html">JDBC</a><br/>
        </blockquote>
</td>
        <td>        <blockquote>
<b>References</b>:<br/>
<a href="api/ado.net/html/annotated.html">ADO.NET</a><br/>
<a href="api/perl/SQLRelay.html">Perl DBI</a><br/>
<a href="api/python/PySQLRDB.py.html">Python DB-API</a><br/>
        </blockquote>
</td>
      </tr>
    </table>

</td>
    <td><div style="margin-left: 60px;"/>
</td>
    <td>    <h4>Native APIs</h4>

    <p>The native SQL Relay client APIs provide advanced features like suspended sessions, result set caching and tuning options.</p>

    <table>
      <tr>
        <td>        <blockquote>
<b>Guides</b>:<br/>
<a href="programming/c++.html">C++</a><br/>
<a href="programming/c.html">C</a><br/>
<a href="programming/cs.html">C#</a><br/>
<a href="programming/perl.html">Perl</a><br/>
<a href="programming/php.html">PHP</a><br/>
<a href="programming/python.html">Python</a><br/>
<a href="programming/ruby.html">Ruby</a><br/>
<a href="programming/java.html">Java</a><br/>
<a href="programming/tcl.html">TCL</a><br/>
<a href="programming/erlang.html">Erlang</a><br/>
<a href="programming/nodejs.html">node.js</a><br/>
        </blockquote>
</td>
        <td>        <blockquote>
<b>References</b>:<br/>
<a href="api/c++/html/annotated.html">C++</a><br/>
<a href="api/c/html/group__sqlrclientwrapper.html">C</a><br/>
<a href="api/cs/html/annotated.html">C#</a><br/>
<a href="api/perl/perl.html">Perl</a><br/>
<a href="api/php/index.html">PHP</a><br/>
<a href="api/python/PySQLRClient.py.html">Python</a><br/>
<a href="api/ruby/doc/index.html">Ruby</a><br/>
<a href="api/java/index.html">Java</a><br/>
<a href="api/tcl/index.html">TCL</a><br/>
<a href="api/erlang/html/index.html">Erlang</a><br/>
<a href="api/nodejs/html/annotated.html">node.js</a><br/>
        </blockquote>
</td>
      </tr>
    </table>

</td>
  </tr>
</table>

<h4>Drop-In Replacement Libraries</h4>

<p>Drop-In Replacement Libraries allow many native MySQL or PostgreSQL applications to use SQL Relay without modification.</p>

<blockquote>
<a href="dropin/mysql.html">MySQL</a><br/>
<a href="dropin/postgresql.html">PostgreSQL</a><br/>
</blockquote>
<hr/>

<h4>Frequently Asked Questions</h4>

<blockquote>
<a href="faq.html">FAQ</a>
</blockquote>
</body>
</html>
